package com.efast.dmom.equipment.dao.masterdata;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.efast.dmom.equipment.bean.EquipIdsParamBean;

public interface EquipMasterDataDao {
	
	public int deleteEquipClassByIds(@Param(value = "id")Integer id);
	
	
	public int deleteEquipCategoryByIds(List<Integer> ids);
	
	public int deleteEquipSpareByIds(List<EquipIdsParamBean> beanList);
	
	public int deleteEquipBaseInfoByIds(List<EquipIdsParamBean> beanList);


	public int getCountByEquipCode(String equipCode);


	public int getSpareCodeQty(@Param("spareCode")String spareCode,@Param("spareCategory") String spareCategory);


	public int getCutterCodeQty(@Param("spareCode") String spareCode,@Param("cutterCode") String cutterCode);


	public int getInboundQtyBySpareId(Integer id);


	public int getOutboundQtyBySpareId(Integer id);


	public int getInventoryById(Integer id);


	public int getStartWorkQtyBySpareId(Integer id);


	public int getRepairInfoQtyBySpareId(Integer id);


	public int getStartWorkQtyByEquipId(Integer id);


	public int getRepairInfoQtyByEquipId(Integer id);
}
